﻿CREATE PROCEDURE [acms].[TopicFile_GetAllByTopicGroupId]
	@TopicGroupId int
AS
	SELECT a.*
	FROM TopicFile_View a 
		inner join Topic_View b on a.TopicId = b.Id
	Order By b.Sequence, a.Name
RETURN 0;